<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!-- #include file="includes/sessao.asp" -->
<html>
<head>
<title>Solic</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<!-- #include file="includes/styles.css" -->
<!-- #include file="includes/conn.asp" -->
<body>
<table width="780" border="0" cellspacing="0" cellpadding="1"><tr><td>
<%    dim rs, consulta
	  set rs = server.createObject("adodb.recordset")
	  consulta = "SELECT * FROM Materiais where estoque = 0 Order by Nome"
	  rs.open consulta,conn,3,3
	  If rs.eof or rs.bof then
%>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr bgcolor="#3399FF"> 
    <td width="1" height="20"></td>
    <td bgcolor="#3399FF"> <div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif">AVISO</font></div></td>
    <td width="1"></td>
  </tr>
  <tr> 
    <td width="1" height="45" bgcolor="#6699CC"></td>
    <td height="45"> <div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        N&atilde;o existe material<br>
        sem estoque.</font></div></td>
    <td width="1" height="45" bgcolor="#6699CC"></td>
  </tr>
  <tr bgcolor="#6699CC"> 
    <td width="1"></td>
    <td height="1"></td>
    <td width="1"></td>
  </tr>
</table>
<br>
<% else %>
<br>
<table width="780" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="11"></td>
    <td width="384"><strong><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">GOVERNO 
      DO ESTADO DA BAHIA</font></strong></td>
    <td width="385"></td>
  </tr>
  <tr> 
    <td></td>
    <td colspan="2"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">SECRETARIA DE DESENVOLVIMENTO SOCIAL - SEDES</font></td>
  </tr>
  <tr> 
    <td></td>
    <td><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif">Diretoria 
      Geral - Coordena&ccedil;&atilde;o de Materiais</font></td>
    <td><div align="right"><font color="#000000"></font></div></td>
  </tr>
</table>
<br>
<br>
<table width="778" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td>
<div align="center"><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><strong>LISTAGEM 
        DE MATERIAL SEM ESTOQUE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</strong></font></div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr align="center" bgcolor="#CCCCCC"> 
          <td width="95"><strong><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;C&Oacute;DIGO</font></strong></td>
          <td width="239"><strong><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">MATERIAL&nbsp;</font></strong></td>
          <td width="29"><strong><font color="#000000" size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;UF</font></strong></td>
        </tr>
        <%		DO WHILE NOT RS.EOF %>
        <tr> 
          <td height="5"></td>
          <td height="5"></td>
          <td height="5"></td>
          <td height="5"></td>
        </tr>
        <tr class="pginicial"> 
          <td valign="top"><%=RS("CODIGO")%></td>
          <td valign="top"><%=RS("NOME")%> - <%=RS("DESCRICAO")%></td>
          <td align="center" valign="top"><%=RS("UF")%></td>
        </tr>
        <tr> 
          <td height="5"></td>
          <td height="5"></td>
          <td height="5"></td>
        </tr>
        <tr> 
          <td height="1" bgcolor="#999999"></td>
          <td height="1" bgcolor="#999999"></td>
          <td height="1" bgcolor="#999999"></td>
        </tr>
        <%
		RS.MOVENEXT
		LOOP
%>
        <tr> 
          <td height="2"></td>
          <td height="2"></td>
          <td height="2"></td>
        </tr>
        <tr> 
          <td height="1" bgcolor="#999999"></td>
          <td height="1" bgcolor="#999999"></td>
          <td height="1" bgcolor="#999999"></td>
        </tr>
      </table></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<%end if%>
<% 
  rs.close
  conn.close
  set rs=nothing
  set conn=nothing
%>
</td></tr></table>
</body>
</html>
